UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J45bLDGjTHyekJ0Muajgdx5RjYzl+dCeB0fUe0m/9ZU='
WHERE
key_id = '80ec9930266d1fe986a3387b73c2e7e8fed55472e35e0edce01b915de0a2eb54'
AND (
token = 'J45bLDGjTHyekJ0Muajgdx5RjYzl+dCeB0fUe0m/9ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)