UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcKHBmt+Pmo2MifMvnv9uMmBYrbki5upXttZ1HQQJpw='
WHERE
key_id = '3e59ed884a9446a2a90fd03c212750c44b8ecd0002dc560f32ee308b414cd323'
AND (
token = 'BcKHBmt+Pmo2MifMvnv9uMmBYrbki5upXttZ1HQQJpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)