UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HoptUNKDY9WQCNb/DRFylP4WB6B73tSp6E6QQ2e2yRM='
WHERE
key_id = 'bef955646cfa0080b75e95756f73deb005b9930ee16919829beb7ab380403bfe'
AND (
token = 'HoptUNKDY9WQCNb/DRFylP4WB6B73tSp6E6QQ2e2yRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)