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