UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnR73fmk5WfjLvewk7L0fWhmfodFdbIhDwGfs63XuDA='
WHERE
key_id = '50d677adc86024a5a4ac5908fe099ba9cade709622bac5245a29de2cb62e50bf'
AND (
token = 'HnR73fmk5WfjLvewk7L0fWhmfodFdbIhDwGfs63XuDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)