UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GqTcuJOxYUqt9RvWMTXKRHL83fFFk+EMVol/ibYipE='
WHERE
key_id = '1b26fb838f93b49df397781339b6145543c2e4b4e5338a3618a7931fa5461800'
AND (
token = '7GqTcuJOxYUqt9RvWMTXKRHL83fFFk+EMVol/ibYipE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)