UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFog0PfCCls6tBQ+gbYu0E81nzdAy3ov6HquAc4CntE='
WHERE
key_id = 'c5f9de0e4596d0ffc519896cc8dcfdabb0346d85489f713e2d175277b7f1fe8e'
AND (
token = 'XFog0PfCCls6tBQ+gbYu0E81nzdAy3ov6HquAc4CntE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)