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