UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wNxf62FF9Ena4b+JXMxl6287KZNuQMgI8CBjwyvVvJk='
WHERE
key_id = '8c1bc775d1aae28b714abbbec50e8b5096068fa8401b2417fe1c1b1106af6d03'
AND (
token = 'wNxf62FF9Ena4b+JXMxl6287KZNuQMgI8CBjwyvVvJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)