UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g2RFqL+SGf/wl5hQCBCxJLd5RDEvT/kqSj2SZk729O0='
WHERE
key_id = 'c7a71d18399623d5bd2a40a94102a07868bdde8505bbda12d89e16030b812baf'
AND (
token = 'g2RFqL+SGf/wl5hQCBCxJLd5RDEvT/kqSj2SZk729O0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)