UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XI0XgtvLHz4AqXs1dMgP9Ch/+DILE0zGOoV/okxyNYU='
WHERE
key_id = 'd7682f34bd9d791678a0d2806a81b7f47727455187f495ad7585fa9df1854960'
AND (
token = 'XI0XgtvLHz4AqXs1dMgP9Ch/+DILE0zGOoV/okxyNYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)