UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJUi+tWTbyOHbLbp+208uR6OYWWuIMbw1ViPmaLJFpA='
WHERE
key_id = 'd7786346321889c46646aa4df4d6ee5a37747adeeeb6b9c8f8c731afde01eae3'
AND (
token = 'xJUi+tWTbyOHbLbp+208uR6OYWWuIMbw1ViPmaLJFpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)