UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGkOzE2qxffOvOiU6cAL9lvJP5WKxfXOhtR1/A8/3jc='
WHERE
key_id = '0bd42e4d45f43bfe87bb8e8a947f3bda0a3d2b68c9f8f9046768d46b154bc3e5'
AND (
token = 'hGkOzE2qxffOvOiU6cAL9lvJP5WKxfXOhtR1/A8/3jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)