UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHgucD+ql49FdylGSx1ZhaRjz1FcvZcCaBonzPY8B3s='
WHERE
key_id = 'b738281d274bb6edd7286246923b197929631864e521243acdf9e3cfa51a09de'
AND (
token = 'KHgucD+ql49FdylGSx1ZhaRjz1FcvZcCaBonzPY8B3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)