UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KfHEiLbb5cRz7SdikpGaSHZlIIafkpaEKgMdbQqBgQA='
WHERE
key_id = '9c05e6e5a125f6eb46f76f5e93fb802df1effbaa9dccf932567d0507e3eee37b'
AND (
token = 'KfHEiLbb5cRz7SdikpGaSHZlIIafkpaEKgMdbQqBgQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)