UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tWP/c67Am3dgB/rSvbgb+Qu5AR++P1A+fBp6vWp3XOo='
WHERE
key_id = '797b78b4290667db97450c1e693ca88a02493602b572c46427953d3363d3cc53'
AND (
token = 'tWP/c67Am3dgB/rSvbgb+Qu5AR++P1A+fBp6vWp3XOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)