UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nUKhE1jkdojcIMvOtvJI3XhmC8iuDueMA/o19+sZAw='
WHERE
key_id = 'ea916f2b745ff71f64d5570a70b55c974bf2ff44058b61d8d6902354e843a8d2'
AND (
token = '8nUKhE1jkdojcIMvOtvJI3XhmC8iuDueMA/o19+sZAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)