UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TZxwYvzN/od7mPKAyPm9rEW4MfwiYUOSb5M43MXrcg='
WHERE
key_id = '06f579289a4cceee046b62eb20dfb2d32330af5cb78f548b4cd472ddf48ec1f3'
AND (
token = '6TZxwYvzN/od7mPKAyPm9rEW4MfwiYUOSb5M43MXrcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)