UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3zsZb6LQVlqajgUgRsonnGG8IOMZVDqFv2VUx6YmLoo='
WHERE
key_id = 'fa33f01d1c585faff33860d08b1a2af1eea55a2d039a6e0110942322acd6b75d'
AND (
token = '3zsZb6LQVlqajgUgRsonnGG8IOMZVDqFv2VUx6YmLoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)