UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNHxBcTY2EyJDby6TWKMf2LHquMUWj3EKUx0lcQeJkc='
WHERE
key_id = '4ae4fe30469a516fb389a170f43f40e556c4dbbbd792f0137e9957a1e6c3dc11'
AND (
token = 'ZNHxBcTY2EyJDby6TWKMf2LHquMUWj3EKUx0lcQeJkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)