UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4PMPuY54w7WfS2WWtgptaLGmMmevt+3vSRGDyu49Hc='
WHERE
key_id = '0f8228c641bcffe3d710f65b0ebf9b07679911db84b6e419a9e6be5dd62a1b03'
AND (
token = 'J4PMPuY54w7WfS2WWtgptaLGmMmevt+3vSRGDyu49Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)