UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6QtAFdJegjj3W+W/9fNoHjXujED6IQdEoFRFqDvyFs='
WHERE
key_id = 'f01e71b269850e1335908bfd8f2001ec31efcd000edfcc490bd58345fc595283'
AND (
token = 'r6QtAFdJegjj3W+W/9fNoHjXujED6IQdEoFRFqDvyFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)