UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vSO1cVo5gGxDzyNVElfoqCs+dzB7ajqSXcXBJPsgLt4='
WHERE
key_id = '9b0716ac7910596d7409934793ef4ce9bece30325b1dad7db5ce32582d7c4826'
AND (
token = 'vSO1cVo5gGxDzyNVElfoqCs+dzB7ajqSXcXBJPsgLt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)