UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyG6+I0VAHFUXgl9WockcA4Sien1RSuR1pfgaVc58ZA='
WHERE
key_id = 'fc4f9c32d3445f0d8bbb17c4ca8086e530451076e34ce9322abfe8c928d03bea'
AND (
token = 'QyG6+I0VAHFUXgl9WockcA4Sien1RSuR1pfgaVc58ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)