UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sAT5MT9E2+5KlVlz1t+Bn/ynzlRcnFOrq2w+uPAU58='
WHERE
key_id = 'e4ecfd43d0c1a7d4f3f6a0ab1014622e48a1c8a46ae4d8c6a273487b8fdccdda'
AND (
token = '0sAT5MT9E2+5KlVlz1t+Bn/ynzlRcnFOrq2w+uPAU58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)