UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGDzd6CeZRIxY393HTliWDvyqynv7E9NJw7b8GxfpBY='
WHERE
key_id = 'bfbfcaa146c3cacde364f1f934552e2de78404537fa18dd8c6f405d075c4d7c9'
AND (
token = 'CGDzd6CeZRIxY393HTliWDvyqynv7E9NJw7b8GxfpBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)