UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VA30Z32bFYl89yh+6v8v1ucxSTTy0rZYQhW8BRxWE8M='
WHERE
key_id = '3e0c3557b2f5c9a99bb31c99760444b08b3358bded460e52ee070407a92b317a'
AND (
token = 'VA30Z32bFYl89yh+6v8v1ucxSTTy0rZYQhW8BRxWE8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)