UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfSZ21gpAVjcKTaTeB7eplERWRNa8BNVwf/QopSsqhc='
WHERE
key_id = 'faaeeab46d38ec1b4ab570370700a25f37443ffa7a48173602616c6b9b832685'
AND (
token = 'ZfSZ21gpAVjcKTaTeB7eplERWRNa8BNVwf/QopSsqhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)