UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kWvnp91JkTHD9mM+1D8A0RMTFENHcVrbrYJJRQnHn4='
WHERE
key_id = '7a814916c024a8c6e7351a9e61d7f510b0a5901cb4b02574ada416813843f60d'
AND (
token = '0kWvnp91JkTHD9mM+1D8A0RMTFENHcVrbrYJJRQnHn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)