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