UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99MNLq4HCFxFNx/qfafmtk7wFh9dz4jZ7vSTXnUVgW0='
WHERE
key_id = 'a8acfd0b9343e1f22f36a1aac38a5cc46135b85bf7d2f44df43c940a365eb2b4'
AND (
token = '99MNLq4HCFxFNx/qfafmtk7wFh9dz4jZ7vSTXnUVgW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)