UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RNcPkoBsYVS81PqVWsTOFbyCxt3ygjXRC+8NSn2KKw='
WHERE
key_id = '0cd904ad0952508dc333c4ffbead85f2ec432e3a87aafda6a90684118887411c'
AND (
token = '7RNcPkoBsYVS81PqVWsTOFbyCxt3ygjXRC+8NSn2KKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)