UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mA8w+g3we67Nnm1F7UBPI1Ue6YHcphM36BNiTZjbg/c='
WHERE
key_id = 'afcd22175aaab26cbac2ccfa776eb36330109e508cdea304079c44eb57ae475c'
AND (
token = 'mA8w+g3we67Nnm1F7UBPI1Ue6YHcphM36BNiTZjbg/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)