UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6VWdCZ9l65b5hjpBaCdu6lK8C93r6y7E8jaEN+MXTEY='
WHERE
key_id = 'b74c333bce9dc5ac3154065d91165e2445a028cdc614abaf5f1404760e883849'
AND (
token = '6VWdCZ9l65b5hjpBaCdu6lK8C93r6y7E8jaEN+MXTEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)