UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBiQ5WhMDZDv4BWVNbxtjSiHryh6PBLcZBcmOXJ3yEg='
WHERE
key_id = '0b2686a702abac03c567ab123293dfe93b50f4efbdb87a92a645aac157fa76d2'
AND (
token = 'tBiQ5WhMDZDv4BWVNbxtjSiHryh6PBLcZBcmOXJ3yEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)