UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NAwo/1M8sCkOVECGmWnmMxTSzQiXKDmjsCFG2aiLjW8='
WHERE
key_id = '4b167bba7f9362c0d112f9580a412455e58cd6ea489e2597e9053b32c5810115'
AND (
token = 'NAwo/1M8sCkOVECGmWnmMxTSzQiXKDmjsCFG2aiLjW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)