UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgDuj4av+3GOJr6N5r9uCv9vYFJXeba0/9pSNb1SDUk='
WHERE
key_id = '65cdcf70d60afda8259f275f16179dd555559014a922a799ca1cc243f80fd6b6'
AND (
token = 'SgDuj4av+3GOJr6N5r9uCv9vYFJXeba0/9pSNb1SDUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)