UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O6Uk8k+dUheEx9KfQebAMkz+wOAxqYgif9Az7fQdLq4='
WHERE
key_id = 'bcdabe6cfe221d0d9247b62d0eb19d4c3248d644d48e3fe9ff49d61c5ccc6ab3'
AND (
token = 'O6Uk8k+dUheEx9KfQebAMkz+wOAxqYgif9Az7fQdLq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)