UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ls8HUd65UrxYQMQeXDLHkrVBTBAZzif8cxQF6fbNrRk='
WHERE
key_id = '4d9be9cca05bd56ff0b3d270b617d3865b1f3bba63513938566e78b957987ef4'
AND (
token = 'ls8HUd65UrxYQMQeXDLHkrVBTBAZzif8cxQF6fbNrRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)