UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fSTkqmDffVbOc3pj0RyS8GwBufnNRUCRRYpeWVtC6g='
WHERE
key_id = 'b9867392aee5385a1a9f1acc385e22d93a8ecafbf9dfab8e59d598f07cf1ffc1'
AND (
token = '8fSTkqmDffVbOc3pj0RyS8GwBufnNRUCRRYpeWVtC6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)