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