UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hR8unNcqr1mrNsEbRgF7yYB0mm5j2JotKQUH6T46yvo='
WHERE
key_id = 'd9863526fa35a59e9fae52419724b4a576f3407c20719d22dc7dad4e3b2dd0b8'
AND (
token = 'hR8unNcqr1mrNsEbRgF7yYB0mm5j2JotKQUH6T46yvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)