UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7bfOndSKjYQLp1HHKGLpnQK3n60eF3gLWy9W0t1F9k='
WHERE
key_id = 'fe8e13b60eb34851eb609c02f7dcc1174787c3df07626b0c2bbfc651153c2eb1'
AND (
token = 'B7bfOndSKjYQLp1HHKGLpnQK3n60eF3gLWy9W0t1F9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)