UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQG0SFgaJkQFf8xAMrNpuf5tBrlr+JI/w14ZTzyYKQQ='
WHERE
key_id = '06d6216018993e95b7221ab944a5400e87f67201cdb83792a252916935a55627'
AND (
token = 'gQG0SFgaJkQFf8xAMrNpuf5tBrlr+JI/w14ZTzyYKQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)